<?php

namespace App\Jobs\Vip;

use App\Constants\TemplateMessageConstant;
use App\Jobs\Message\SendMessage;
use App\Models\Member;
use Illuminate\Bus\Queueable;
use Illuminate\Contracts\Queue\ShouldBeUnique;
use Illuminate\Contracts\Queue\ShouldQueue;
use Illuminate\Foundation\Bus\Dispatchable;
use Illuminate\Queue\InteractsWithQueue;
use Illuminate\Queue\SerializesModels;

class Due implements ShouldQueue
{
    use Dispatchable, InteractsWithQueue, Queueable, SerializesModels;

    /**
     * Create a new job instance.
     *
     * @return void
     */
    public function __construct()
    {
        //
    }

    /**
     * Execute the job.
     *
     * @return void
     */
    public function handle()
    {
        Member::query()->where('is_vip', '=', 1)
            ->where('vip_end_time', '<', strtotime(date('Y-m-d 23:59:59', time())) - 24 * 3600)
            ->chunkById(500, function ($members) {
                $members->pluck('id')->each(function ($id) {
                    SendMessage::dispatch($id, TemplateMessageConstant::VIP_DUE_NOTICE);
                });
            });
    }
}
